By default, the registration of an Oracle spatial table as a feature will define properties as Text Properties. To enhance this, the Bentley Map – Oracle functionality provides the ability to identify lookup tables in Oracle and use them as XFM domain lists. This way, properties can be defined as pick lists (Option List Properties).

Configuring tables for use as domain lists is a two-step process:

• First, a lookup table needs to be either created or already present in the database;

• Second, a foreign key is added to ‘formalize’ the relationship between the lookup table and the parent table.